Oracle 密码过期策略

1 查看某个用户的Profile

SELECT username,PROFILE FROM dba_users WHERE username IN ('SYSTEM','OA11');

2 更改默认profile策略

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

3 查询当前过期策略

SET LINES 66
COL username FOR A15
COL password  FOR A15
COL account_status  FOR A15
SELECT username,password,expiry_date,account_status FROM dba_users WHERE username IN ('SYSTEM','OA11');

4 更改用户密码并验证

ALTER USER system IDENTIFIED BY oracle ACCOUNT UNLOCK;
ALTER USER OA11 identified by oa11 ACCOUNT UNLOCK;
conn OA11/oa11@127.0.0.1:1521/citdb
conn system/oracle@127.0.0.1:1521/citdb